package com.dq.repository.service;

import com.dq.domain.service.ServiceProject;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author cf
 * 岗位
 */
public interface ServiceProjectRepository extends JpaRepository<ServiceProject, Long> {

    /**
     * 根据岗位名称获取
     * @param deleted
     * @param postName
     * @return
     */
    List<ServiceProject> findByDeletedAndProjectName(Boolean deleted, String postName);

    /**
     * id Jihe
     * @param ids
     * @return
     */
    List<ServiceProject> findByIdIn(List<Long> ids);
    ServiceProject findByProjectNameAndDeletedFalse(String projectName);
    Long countByProjectName(String projectName);
    List<ServiceProject> findByDeletedFalse(Pageable pageable);
    Long countByDeletedFalse();

    List<ServiceProject> findByDeletedFalse();
}
